Dataset statistics
| Number of variables | 45 |
|---|---|
| Number of observations | 6771 |
| Missing cells | 96 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 191 |
| Duplicate rows (%) | 2.8% |
| Total size in memory | 2.3 MiB |
| Average record size in memory | 360.0 B |
Variable types
| CAT | 33 |
|---|---|
| NUM | 10 |
| BOOL | 2 |
emd_lable has constant value "6771" | Constant |
emd_lable2 has constant value "6771" | Constant |
| Dataset has 191 (2.8%) duplicate rows | Duplicates |
pax_name has a high cardinality: 6489 distinct values | High cardinality |
pax_passport has a high cardinality: 6447 distinct values | High cardinality |
pref_line_y3_1 has a high cardinality: 144 distinct values | High cardinality |
pref_line_y3_2 has a high cardinality: 156 distinct values | High cardinality |
pref_line_y3_3 has a high cardinality: 175 distinct values | High cardinality |
pref_line_y3_4 has a high cardinality: 147 distinct values | High cardinality |
pref_line_y3_5 has a high cardinality: 147 distinct values | High cardinality |
pref_city_y3_2 has a high cardinality: 83 distinct values | High cardinality |
pref_city_y3_3 has a high cardinality: 88 distinct values | High cardinality |
flt_cnt_y3 has a high cardinality: 91 distinct values | High cardinality |
avg_dist_cnt_y3 is highly correlated with avg_dist_cnt_y2 | High correlation |
avg_dist_cnt_y2 is highly correlated with avg_dist_cnt_y3 | High correlation |
tkt_avg_amt_y3 is highly correlated with tkt_avg_amt_y2 | High correlation |
tkt_avg_amt_y2 is highly correlated with tkt_avg_amt_y3 | High correlation |
seg_flight is highly correlated with seg_route_to | High correlation |
seg_route_to is highly correlated with seg_flight | High correlation |
pit_add_chnl_y3 has 96 (1.4%) missing values | Missing |
seat_window_cnt_y3 is highly skewed (γ1 = 25.06414781) | Skewed |
pax_name is uniformly distributed | Uniform |
pax_passport is uniformly distributed | Uniform |
seat_walkway_cnt_y3 has 6129 (90.5%) zeros | Zeros |
seat_window_cnt_y3 has 6289 (92.9%) zeros | Zeros |
seat_middle_cnt_y3 has 6353 (93.8%) zeros | Zeros |
avg_dist_cnt_y2 has 6084 (89.9%) zeros | Zeros |
avg_dist_cnt_y3 has 6086 (89.9%) zeros | Zeros |
flt_leg_i_cnt_y3 has 6004 (88.7%) zeros | Zeros |
mdl_mcv has 6103 (90.1%) zeros | Zeros |
tkt_avg_amt_y1 has 6266 (92.5%) zeros | Zeros |
tkt_avg_amt_y2 has 6128 (90.5%) zeros | Zeros |
tkt_avg_amt_y3 has 6102 (90.1%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-11 15:50:35.600437 |
|---|---|
| Analysis finished | 2021-03-11 15:51:09.173269 |
| Duration | 33.57 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 6489 |
|---|---|
| Distinct (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 884e2983a0740b728adb5aa8be5d5837 | 5 |
|---|---|
| 6e32e5d6e1649f0c73bcc509b5c8e3b9 | 4 |
| dc81215b4e423a7eae9bbc85bc4ae95b | 4 |
| 7623c905c7b5f3155e67e1647008c985 | 4 |
| f1472740493d0096a47c88dd497fb18b | 3 |
| Other values (6484) |
| Value | Count | Frequency (%) | |
| 884e2983a0740b728adb5aa8be5d5837 | 5 | 0.1% | |
| 6e32e5d6e1649f0c73bcc509b5c8e3b9 | 4 | 0.1% | |
| dc81215b4e423a7eae9bbc85bc4ae95b | 4 | 0.1% | |
| 7623c905c7b5f3155e67e1647008c985 | 4 | 0.1% | |
| f1472740493d0096a47c88dd497fb18b | 3 | < 0.1% | |
| e3133705b3ab483acb909361197e66e8 | 3 | < 0.1% | |
| ecd4cc8f063a1ad4d64ce5db74e84e8c | 3 | < 0.1% | |
| d933b7ab2b0b2587eba24c5bb9da5ff7 | 3 | < 0.1% | |
| fc4e5102e5da3d80649ac88dd3ef1626 | 3 | < 0.1% | |
| 779999ae7a2cf515220842c0d27ca4d9 | 3 | < 0.1% | |
| Other values (6479) | 6736 | 99.5% |
Unique
| Unique | 6236 ? |
|---|---|
| Unique (%) | 92.1% |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
| Distinct | 6447 |
|---|---|
| Distinct (%) | 95.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0cf357779a8597a092bdb7e8c4dd0fb9 | 5 |
|---|---|
| 04706e7ca865da4e565d92593968add9 | 5 |
| a64fed95293b981720bb553074f2fc06 | 5 |
| eb2cb640b74cf4ff8354d97832969515 | 4 |
| 5fcafded7a9ecb863973769193664b22 | 4 |
| Other values (6442) |
| Value | Count | Frequency (%) | |
| 0cf357779a8597a092bdb7e8c4dd0fb9 | 5 | 0.1% | |
| 04706e7ca865da4e565d92593968add9 | 5 | 0.1% | |
| a64fed95293b981720bb553074f2fc06 | 5 | 0.1% | |
| eb2cb640b74cf4ff8354d97832969515 | 4 | 0.1% | |
| 5fcafded7a9ecb863973769193664b22 | 4 | 0.1% | |
| eba97d2a193f832add8c2db9aa23a82f | 3 | < 0.1% | |
| ee5657503f9828f74bb82e1aeb820b54 | 3 | < 0.1% | |
| d1f777e74758cb7bbaf362c74bfbc9da | 3 | < 0.1% | |
| dbe116c4a1eb51b0c6cb14e9f62a11e5 | 3 | < 0.1% | |
| fd709cf0b693eb678b6f22b53f64eea8 | 3 | < 0.1% | |
| Other values (6437) | 6733 | 99.4% |
Unique
| Unique | 6165 ? |
|---|---|
| Unique (%) | 91.1% |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| LAX | |
|---|---|
| JFK |
| Value | Count | Frequency (%) | |
| LAX | 3493 | 51.6% | |
| JFK | 3278 | 48.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| AB1008 | |
|---|---|
| AB1006 | |
| AB1009 | |
| AB1010 | |
| AB1015 | 25 |
| Value | Count | Frequency (%) | |
| AB1008 | 2028 | 30.0% | |
| AB1006 | 1925 | 28.4% | |
| AB1009 | 1440 | 21.3% | |
| AB1010 | 1353 | 20.0% | |
| AB1015 | 25 | 0.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
seg_cabin
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| Y | |
|---|---|
| J | |
| F | 1 |
| Value | Count | Frequency (%) | |
| Y | 5845 | 86.3% | |
| J | 925 | 13.7% | |
| F | 1 | < 0.1% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 6771 | 100.0% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 6771 | 100.0% |
gender
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| M | 188 |
| F | 176 |
| U | 6 |
| Value | Count | Frequency (%) | |
| 0 | 6401 | 94.5% | |
| M | 188 | 2.8% | |
| F | 176 | 2.6% | |
| U | 6 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
age
Categorical
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 21-30 | 77 |
| 31-40 | 74 |
| 60+ | 64 |
| 51-60 | 62 |
| Other values (8) | 53 |
| Value | Count | Frequency (%) | |
| 0 | 6441 | 95.1% | |
| 21-30 | 77 | 1.1% | |
| 31-40 | 74 | 1.1% | |
| 60+ | 64 | 0.9% | |
| 51-60 | 62 | 0.9% | |
| 41-50 | 45 | 0.7% | |
| 11朿0旿2002/2/10 | 2 | < 0.1% | |
| 11朿0旿2002/3/21 | 1 | < 0.1% | |
| 0-10 | 1 | < 0.1% | |
| 11朿0旿2008/5/30 | 1 | < 0.1% | |
| Other values (3) | 3 | < 0.1% |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 1 |
| Mean length | 1.185349284 |
| Min length | 1 |
residence_country
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 中国 | 341 |
| 美国 | 10 |
| 新加坿0 | 1 |
| 加拿夿0 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 6418 | 94.8% | |
| 中国 | 341 | 5.0% | |
| 美国 | 10 | 0.1% | |
| 新加坿0 | 1 | < 0.1% | |
| 加拿夿0 | 1 | < 0.1% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 4 |
|---|---|
| Median length | 1 |
| Mean length | 1.052724856 |
| Min length | 1 |
nation_name
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 美国 | 157 |
| 中国 | 95 |
| 韩国 | 6 |
| 菲律宿0 | 4 |
| Other values (16) | 29 |
| Value | Count | Frequency (%) | |
| 0 | 6480 | 95.7% | |
| 美国 | 157 | 2.3% | |
| 中国 | 95 | 1.4% | |
| 韩国 | 6 | 0.1% | |
| 菲律宿0 | 4 | 0.1% | |
| 中国台湾 | 4 | 0.1% | |
| 新加坿0 | 4 | 0.1% | |
| 泰国 | 3 | < 0.1% | |
| 墨西哿0 | 3 | < 0.1% | |
| 马来西亚 | 2 | < 0.1% | |
| Other values (11) | 13 | 0.2% |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 1 |
| Mean length | 1.051247969 |
| Min length | 1 |
province_name
Categorical
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| SH | 31 |
| JS | 11 |
| ZJ | 7 |
| AH | 7 |
| Other values (23) | 38 |
| Value | Count | Frequency (%) | |
| 0 | 6677 | 98.6% | |
| SH | 31 | 0.5% | |
| JS | 11 | 0.2% | |
| ZJ | 7 | 0.1% | |
| AH | 7 | 0.1% | |
| NY | 5 | 0.1% | |
| U | 3 | < 0.1% | |
| S | 3 | < 0.1% | |
| BJ | 3 | < 0.1% | |
| HA | 2 | < 0.1% | |
| Other values (18) | 22 | 0.3% |
Unique
| Unique | 14 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 12 |
|---|---|
| Median length | 1 |
| Mean length | 1.02230099 |
| Min length | 1 |
member_level
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| STD | 237 |
| SILHL | 15 |
| GOLHL | 12 |
| PLTSL | 10 |
| Value | Count | Frequency (%) | |
| 0 | 6495 | 95.9% | |
| STD | 237 | 3.5% | |
| SILHL | 15 | 0.2% | |
| GOLHL | 12 | 0.2% | |
| PLTSL | 10 | 0.1% | |
| 网站 | 2 | < 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 5 |
|---|---|
| Median length | 1 |
| Mean length | 1.092157732 |
| Min length | 1 |
enroll_chnl
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 网站 | 223 |
| 销售单使0 | 16 |
| 手机平台 | 16 |
| 其它 | 8 |
| Other values (2) | 11 |
| Value | Count | Frequency (%) | |
| 0 | 6497 | 96.0% | |
| 网站 | 223 | 3.3% | |
| 销售单使0 | 16 | 0.2% | |
| 手机平台 | 16 | 0.2% | |
| 其它 | 8 | 0.1% | |
| 电话 | 6 | 0.1% | |
| 移动客舱 | 5 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 5 |
|---|---|
| Median length | 1 |
| Mean length | 1.053758677 |
| Min length | 1 |
pref_aircraft_m3_1
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | 185 |
| 33L | 14 |
| 320 | 9 |
| 73E | 8 |
| Other values (10) | 36 |
| Value | Count | Frequency (%) | |
| 0 | 6519 | 96.3% | |
| 773 | 185 | 2.7% | |
| 33L | 14 | 0.2% | |
| 320 | 9 | 0.1% | |
| 73E | 8 | 0.1% | |
| 73H | 7 | 0.1% | |
| 33E | 6 | 0.1% | |
| 33H | 5 | 0.1% | |
| 738 | 4 | 0.1% | |
| 73L | 4 | 0.1% | |
| Other values (5) | 10 | 0.1% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.074435091 |
| Min length | 1 |
pref_aircraft_m3_2
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | 86 |
| 33L | 22 |
| 325 | 17 |
| 73E | 15 |
| Other values (15) | 109 |
| Value | Count | Frequency (%) | |
| 0 | 6522 | 96.3% | |
| 773 | 86 | 1.3% | |
| 33L | 22 | 0.3% | |
| 325 | 17 | 0.3% | |
| 73E | 15 | 0.2% | |
| 738 | 13 | 0.2% | |
| 33E | 12 | 0.2% | |
| 320 | 12 | 0.2% | |
| 323 | 11 | 0.2% | |
| 73H | 9 | 0.1% | |
| Other values (10) | 52 | 0.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.073548959 |
| Min length | 1 |
pref_aircraft_y3_1
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | |
| 320 | 38 |
| 73H | 33 |
| 325 | 23 |
| Other values (16) | 119 |
| Value | Count | Frequency (%) | |
| 0 | 5924 | 87.5% | |
| 773 | 634 | 9.4% | |
| 320 | 38 | 0.6% | |
| 73H | 33 | 0.5% | |
| 325 | 23 | 0.3% | |
| 33L | 19 | 0.3% | |
| 33E | 18 | 0.3% | |
| 73E | 15 | 0.2% | |
| 333 | 15 | 0.2% | |
| 33H | 11 | 0.2% | |
| Other values (11) | 41 | 0.6% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.250184611 |
| Min length | 1 |
pref_aircraft_y3_2
Categorical
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | 223 |
| 325 | 113 |
| 73H | 91 |
| 320 | 82 |
| Other values (19) | 330 |
| Value | Count | Frequency (%) | |
| 0 | 5932 | 87.6% | |
| 773 | 223 | 3.3% | |
| 325 | 113 | 1.7% | |
| 73H | 91 | 1.3% | |
| 320 | 82 | 1.2% | |
| 33E | 51 | 0.8% | |
| 33L | 47 | 0.7% | |
| 73E | 35 | 0.5% | |
| 333 | 34 | 0.5% | |
| 33H | 30 | 0.4% | |
| Other values (14) | 133 | 2.0% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.247821592 |
| Min length | 1 |
pref_aircraft_y3_3
Categorical
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | 167 |
| 73H | 57 |
| 320 | 55 |
| 325 | 52 |
| Other values (20) | 310 |
| Value | Count | Frequency (%) | |
| 0 | 6130 | 90.5% | |
| 773 | 167 | 2.5% | |
| 73H | 57 | 0.8% | |
| 320 | 55 | 0.8% | |
| 325 | 52 | 0.8% | |
| 73E | 38 | 0.6% | |
| 738 | 36 | 0.5% | |
| 321 | 32 | 0.5% | |
| 33E | 30 | 0.4% | |
| 33L | 27 | 0.4% | |
| Other values (15) | 147 | 2.2% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.189336878 |
| Min length | 1 |
pref_aircraft_y3_4
Categorical
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | 156 |
| 325 | 37 |
| 320 | 32 |
| 73E | 28 |
| Other values (18) | 187 |
| Value | Count | Frequency (%) | |
| 0 | 6331 | 93.5% | |
| 773 | 156 | 2.3% | |
| 325 | 37 | 0.5% | |
| 320 | 32 | 0.5% | |
| 73E | 28 | 0.4% | |
| 73H | 27 | 0.4% | |
| 738 | 21 | 0.3% | |
| 33H | 18 | 0.3% | |
| 33E | 18 | 0.3% | |
| 33L | 17 | 0.3% | |
| Other values (13) | 86 | 1.3% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.129966032 |
| Min length | 1 |
pref_aircraft_y3_5
Categorical
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 773 | 137 |
| 325 | 23 |
| 320 | 16 |
| 33E | 13 |
| Other values (23) | 130 |
| Value | Count | Frequency (%) | |
| 0 | 6452 | 95.3% | |
| 773 | 137 | 2.0% | |
| 325 | 23 | 0.3% | |
| 320 | 16 | 0.2% | |
| 33E | 13 | 0.2% | |
| 323 | 12 | 0.2% | |
| 333 | 11 | 0.2% | |
| 33H | 11 | 0.2% | |
| 73H | 11 | 0.2% | |
| 33L | 10 | 0.1% | |
| Other values (18) | 75 | 1.1% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.090680845 |
| Min length | 1 |
| Distinct | 144 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| JFK-PVG | 165 |
| LAX-PVG | 112 |
| PVG-JFK | 58 |
| PVG-LAX | 49 |
| Other values (139) | 347 |
| Value | Count | Frequency (%) | |
| 0 | 6040 | 89.2% | |
| JFK-PVG | 165 | 2.4% | |
| LAX-PVG | 112 | 1.7% | |
| PVG-JFK | 58 | 0.9% | |
| PVG-LAX | 49 | 0.7% | |
| PVG-BKK | 25 | 0.4% | |
| SIN-PVG | 25 | 0.4% | |
| PVG-ICN | 19 | 0.3% | |
| SFO-PVG | 13 | 0.2% | |
| PVG-WNZ | 10 | 0.1% | |
| Other values (134) | 255 | 3.8% |
Unique
| Unique | 73 ? |
|---|---|
| Unique (%) | 1.1% |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.647762517 |
| Min length | 1 |
| Distinct | 156 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| PVG-JFK | 132 |
| JFK-PVG | 91 |
| PVG-LAX | 85 |
| LAX-PVG | 83 |
| Other values (151) | 332 |
| Value | Count | Frequency (%) | |
| 0 | 6048 | 89.3% | |
| PVG-JFK | 132 | 1.9% | |
| JFK-PVG | 91 | 1.3% | |
| PVG-LAX | 85 | 1.3% | |
| LAX-PVG | 83 | 1.2% | |
| BKK-PVG | 16 | 0.2% | |
| PVG-SFO | 11 | 0.2% | |
| PVG-HKG | 10 | 0.1% | |
| PVG-BKK | 9 | 0.1% | |
| PVG-ORD | 7 | 0.1% | |
| Other values (146) | 279 | 4.1% |
Unique
| Unique | 78 ? |
|---|---|
| Unique (%) | 1.2% |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.64067346 |
| Min length | 1 |
| Distinct | 175 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| PVG-LAX | 73 |
| PVG-JFK | 58 |
| JFK-PVG | 42 |
| LAX-PVG | 33 |
| Other values (170) | 360 |
| Value | Count | Frequency (%) | |
| 0 | 6205 | 91.6% | |
| PVG-LAX | 73 | 1.1% | |
| PVG-JFK | 58 | 0.9% | |
| JFK-PVG | 42 | 0.6% | |
| LAX-PVG | 33 | 0.5% | |
| PVG-HKG | 9 | 0.1% | |
| PVG-BKK | 9 | 0.1% | |
| SIN-PVG | 8 | 0.1% | |
| WNZ-PVG | 8 | 0.1% | |
| CAN-PVG | 7 | 0.1% | |
| Other values (165) | 319 | 4.7% |
Unique
| Unique | 84 ? |
|---|---|
| Unique (%) | 1.2% |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.501550731 |
| Min length | 1 |
| Distinct | 147 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| PVG-JFK | 49 |
| PVG-LAX | 34 |
| LAX-PVG | 26 |
| BKK-PVG | 20 |
| Other values (142) | 340 |
| Value | Count | Frequency (%) | |
| 0 | 6302 | 93.1% | |
| PVG-JFK | 49 | 0.7% | |
| PVG-LAX | 34 | 0.5% | |
| LAX-PVG | 26 | 0.4% | |
| BKK-PVG | 20 | 0.3% | |
| JFK-PVG | 18 | 0.3% | |
| ICN-PVG | 16 | 0.2% | |
| PVG-SIN | 13 | 0.2% | |
| KUL-PVG | 11 | 0.2% | |
| FOC-PVG | 9 | 0.1% | |
| Other values (137) | 273 | 4.0% |
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | 1.0% |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.41382366 |
| Min length | 1 |
| Distinct | 147 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| PVG | 14 |
| PVG-JFK | 13 |
| LAX-PVG | 12 |
| JFK-PVG | 12 |
| Other values (142) | 226 |
| Value | Count | Frequency (%) | |
| 0 | 6494 | 95.9% | |
| PVG | 14 | 0.2% | |
| PVG-JFK | 13 | 0.2% | |
| LAX-PVG | 12 | 0.2% | |
| JFK-PVG | 12 | 0.2% | |
| PVG-LAX | 11 | 0.2% | |
| JFK | 5 | 0.1% | |
| BKK-PVG | 5 | 0.1% | |
| KIX-PVG | 5 | 0.1% | |
| ORD-PVG | 4 | 0.1% | |
| Other values (137) | 196 | 2.9% |
Unique
| Unique | 93 ? |
|---|---|
| Unique (%) | 1.4% |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.228326687 |
| Min length | 1 |
pref_city_y3_1
Categorical
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| PVG | |
| SHA | 50 |
| JFK | 41 |
| LAX | 16 |
| Other values (44) | 126 |
| Value | Count | Frequency (%) | |
| 0 | 5923 | 87.5% | |
| PVG | 615 | 9.1% | |
| SHA | 50 | 0.7% | |
| JFK | 41 | 0.6% | |
| LAX | 16 | 0.2% | |
| SIN | 12 | 0.2% | |
| SZX | 8 | 0.1% | |
| TAO | 7 | 0.1% | |
| TYN | 7 | 0.1% | |
| WUH | 7 | 0.1% | |
| Other values (39) | 85 | 1.3% |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.250479988 |
| Min length | 1 |
| Distinct | 83 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| JFK | 193 |
| LAX | 151 |
| PVG | 143 |
| SHA | 33 |
| Other values (78) | 313 |
| Value | Count | Frequency (%) | |
| 0 | 5938 | 87.7% | |
| JFK | 193 | 2.9% | |
| LAX | 151 | 2.2% | |
| PVG | 143 | 2.1% | |
| SHA | 33 | 0.5% | |
| SIN | 30 | 0.4% | |
| PEK | 14 | 0.2% | |
| PUS | 12 | 0.2% | |
| ICN | 11 | 0.2% | |
| NKG | 11 | 0.2% | |
| Other values (73) | 235 | 3.5% |
Unique
| Unique | 29 ? |
|---|---|
| Unique (%) | 0.4% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.246049328 |
| Min length | 1 |
| Distinct | 88 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| JFK | 101 |
| LAX | 94 |
| PVG | 47 |
| ICN | 34 |
| Other values (83) | 344 |
| Value | Count | Frequency (%) | |
| 0 | 6151 | 90.8% | |
| JFK | 101 | 1.5% | |
| LAX | 94 | 1.4% | |
| PVG | 47 | 0.7% | |
| ICN | 34 | 0.5% | |
| SHA | 26 | 0.4% | |
| HKG | 21 | 0.3% | |
| PEK | 19 | 0.3% | |
| BKK | 18 | 0.3% | |
| XIY | 15 | 0.2% | |
| Other values (78) | 245 | 3.6% |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | 0.4% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.183133954 |
| Min length | 1 |
pref_dest_city_y1
Categorical
| Distinct | 46 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| Shanghai | 251 |
| New York | 130 |
| Los Angeles | 57 |
| Beijing | 9 |
| Other values (41) | 70 |
| Value | Count | Frequency (%) | |
| 0 | 6254 | 92.4% | |
| Shanghai | 251 | 3.7% | |
| New York | 130 | 1.9% | |
| Los Angeles | 57 | 0.8% | |
| Beijing | 9 | 0.1% | |
| TAIPEI | 6 | 0.1% | |
| BANGKOK | 4 | 0.1% | |
| Nanjing | 3 | < 0.1% | |
| Seoul | 3 | < 0.1% | |
| Yantai | 3 | < 0.1% | |
| Other values (36) | 51 | 0.8% |
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 22 |
|---|---|
| Median length | 1 |
| Mean length | 1.554127898 |
| Min length | 1 |
pref_dest_city_y2
Categorical
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| Shanghai | 400 |
| New York | 110 |
| Los Angeles | 61 |
| Beijing | 8 |
| Other values (40) | 76 |
| Value | Count | Frequency (%) | |
| 0 | 6116 | 90.3% | |
| Shanghai | 400 | 5.9% | |
| New York | 110 | 1.6% | |
| Los Angeles | 61 | 0.9% | |
| Beijing | 8 | 0.1% | |
| TAIPEI | 6 | 0.1% | |
| Fuzhou | 5 | 0.1% | |
| BANGKOK | 4 | 0.1% | |
| SAN FRANCISICO | 4 | 0.1% | |
| Xi'an | 4 | 0.1% | |
| Other values (35) | 53 | 0.8% |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 22 |
|---|---|
| Median length | 1 |
| Mean length | 1.703588835 |
| Min length | 1 |
pref_dest_city_y3
Categorical
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| Shanghai | 436 |
| New York | 99 |
| Los Angeles | 54 |
| Beijing | 9 |
| Other values (35) | 86 |
| Value | Count | Frequency (%) | |
| 0 | 6087 | 89.9% | |
| Shanghai | 436 | 6.4% | |
| New York | 99 | 1.5% | |
| Los Angeles | 54 | 0.8% | |
| Beijing | 9 | 0.1% | |
| TAIPEI | 7 | 0.1% | |
| Xi'an | 6 | 0.1% | |
| Guangzhou | 5 | 0.1% | |
| Nanjing | 5 | 0.1% | |
| SAN FRANCISICO | 4 | 0.1% | |
| Other values (30) | 59 | 0.9% |
Unique
| Unique | 13 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 22 |
|---|---|
| Median length | 1 |
| Mean length | 1.734012701 |
| Min length | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 96 |
| Missing (%) | 1.4% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 航空累积 | 168 |
| 非航累积 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 6502 | 96.0% | |
| 航空累积 | 168 | 2.5% | |
| 非航累积 | 5 | 0.1% | |
| (Missing) | 96 | 1.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 1 |
| Mean length | 1.105006646 |
| Min length | 1 |
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4339093192 |
|---|---|
| Minimum | 0 |
| Maximum | 89 |
| Zeros | 6129 |
| Zeros (%) | 90.5% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 89 |
| Range | 89 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.563151403 |
|---|---|
| Coefficient of variation (CV) | 5.907113053 |
| Kurtosis | 531.6123631 |
| Mean | 0.4339093192 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.98094684 |
| Sum | 2938 |
| Variance | 6.569745114 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6129 | 90.5% | |
| 1 | 133 | 2.0% | |
| 2 | 129 | 1.9% | |
| 3 | 113 | 1.7% | |
| 4 | 69 | 1.0% | |
| 5 | 60 | 0.9% | |
| 6 | 41 | 0.6% | |
| 7 | 19 | 0.3% | |
| 8 | 19 | 0.3% | |
| 9 | 17 | 0.3% | |
| Other values (20) | 42 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 6129 | 90.5% | |
| 1 | 133 | 2.0% | |
| 2 | 129 | 1.9% | |
| 3 | 113 | 1.7% | |
| 4 | 69 | 1.0% |
| Value | Count | Frequency (%) | |
| 89 | 2 | < 0.1% | |
| 58 | 1 | < 0.1% | |
| 54 | 1 | < 0.1% | |
| 48 | 1 | < 0.1% | |
| 47 | 1 | < 0.1% |
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2668734308 |
|---|---|
| Minimum | 0 |
| Maximum | 92 |
| Zeros | 6289 |
| Zeros (%) | 92.9% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 92 |
| Range | 92 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.83140016 |
|---|---|
| Coefficient of variation (CV) | 6.862429708 |
| Kurtosis | 1039.551104 |
| Mean | 0.2668734308 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.06414781 |
| Sum | 1807 |
| Variance | 3.354026545 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6289 | 92.9% | |
| 1 | 152 | 2.2% | |
| 2 | 113 | 1.7% | |
| 3 | 68 | 1.0% | |
| 4 | 50 | 0.7% | |
| 5 | 22 | 0.3% | |
| 8 | 13 | 0.2% | |
| 6 | 13 | 0.2% | |
| 7 | 10 | 0.1% | |
| 9 | 8 | 0.1% | |
| Other values (13) | 33 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 6289 | 92.9% | |
| 1 | 152 | 2.2% | |
| 2 | 113 | 1.7% | |
| 3 | 68 | 1.0% | |
| 4 | 50 | 0.7% |
| Value | Count | Frequency (%) | |
| 92 | 1 | < 0.1% | |
| 48 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 23 | 1 | < 0.1% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1379412199 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 6353 |
| Zeros (%) | 93.8% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7058693479 |
|---|---|
| Coefficient of variation (CV) | 5.117174898 |
| Kurtosis | 128.3190002 |
| Mean | 0.1379412199 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.177940107 |
| Sum | 934 |
| Variance | 0.4982515363 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6353 | 93.8% | |
| 1 | 174 | 2.6% | |
| 2 | 125 | 1.8% | |
| 3 | 60 | 0.9% | |
| 4 | 31 | 0.5% | |
| 6 | 10 | 0.1% | |
| 5 | 9 | 0.1% | |
| 13 | 4 | 0.1% | |
| 9 | 2 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 6353 | 93.8% | |
| 1 | 174 | 2.6% | |
| 2 | 125 | 1.8% | |
| 3 | 60 | 0.9% | |
| 4 | 31 | 0.5% |
| Value | Count | Frequency (%) | |
| 16 | 1 | < 0.1% | |
| 13 | 4 | 0.1% | |
| 9 | 2 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Distinct | 513 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 759.1510111 |
|---|---|
| Minimum | 0 |
| Maximum | 14363.66667 |
| Zeros | 6084 |
| Zeros (%) | 89.9% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7075 |
| Maximum | 14363.66667 |
| Range | 14363.66667 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2492.929081 |
|---|---|
| Coefficient of variation (CV) | 3.283838189 |
| Kurtosis | 11.38700788 |
| Mean | 759.1510111 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.450420344 |
| Sum | 5140211.496 |
| Variance | 6214695.405 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6084 | 89.9% | |
| 13239 | 38 | 0.6% | |
| 10837.5 | 13 | 0.2% | |
| 10867 | 9 | 0.1% | |
| 5975.5 | 8 | 0.1% | |
| 13390 | 7 | 0.1% | |
| 7176.25 | 6 | 0.1% | |
| 13188.66667 | 5 | 0.1% | |
| 13088 | 5 | 0.1% | |
| 3019 | 5 | 0.1% | |
| Other values (503) | 591 | 8.7% |
| Value | Count | Frequency (%) | |
| 0 | 6084 | 89.9% | |
| 407 | 1 | < 0.1% | |
| 490 | 1 | < 0.1% | |
| 490.6666667 | 1 | < 0.1% | |
| 675 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14363.66667 | 1 | < 0.1% | |
| 14363.5 | 2 | < 0.1% | |
| 13390 | 7 | 0.1% | |
| 13314.5 | 1 | < 0.1% | |
| 13289.33333 | 1 | < 0.1% |
| Distinct | 540 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 745.2562932 |
|---|---|
| Minimum | 0 |
| Maximum | 14363.66667 |
| Zeros | 6086 |
| Zeros (%) | 89.9% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7075 |
| Maximum | 14363.66667 |
| Range | 14363.66667 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2452.161296 |
|---|---|
| Coefficient of variation (CV) | 3.290359731 |
| Kurtosis | 11.42732767 |
| Mean | 745.2562932 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.454084287 |
| Sum | 5046130.361 |
| Variance | 6013095.023 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6086 | 89.9% | |
| 13239 | 23 | 0.3% | |
| 10837.5 | 13 | 0.2% | |
| 13103 | 9 | 0.1% | |
| 12967 | 8 | 0.1% | |
| 3019 | 6 | 0.1% | |
| 7176.25 | 6 | 0.1% | |
| 10867 | 5 | 0.1% | |
| 13188.66667 | 4 | 0.1% | |
| 13390 | 4 | 0.1% | |
| Other values (530) | 607 | 9.0% |
| Value | Count | Frequency (%) | |
| 0 | 6086 | 89.9% | |
| 1 | 1 | < 0.1% | |
| 407 | 1 | < 0.1% | |
| 490 | 1 | < 0.1% | |
| 490.6666667 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14363.66667 | 1 | < 0.1% | |
| 14363.5 | 2 | < 0.1% | |
| 13390 | 4 | 0.1% | |
| 13289.33333 | 1 | < 0.1% | |
| 13269.2 | 1 | < 0.1% |
| Distinct | 91 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 4 | 131 |
| 2 | 83 |
| 6 | 81 |
| 3 | 74 |
| Other values (86) | 375 |
| Value | Count | Frequency (%) | |
| 0 | 6027 | 89.0% | |
| 4 | 131 | 1.9% | |
| 2 | 83 | 1.2% | |
| 6 | 81 | 1.2% | |
| 3 | 74 | 1.1% | |
| 8 | 56 | 0.8% | |
| 5 | 48 | 0.7% | |
| 7 | 31 | 0.5% | |
| 1 | 29 | 0.4% | |
| 10 | 23 | 0.3% | |
| Other values (81) | 188 | 2.8% |
Unique
| Unique | 55 ? |
|---|---|
| Unique (%) | 0.8% |
Length
| Max length | 10 |
|---|---|
| Median length | 1 |
| Mean length | 1.090680845 |
| Min length | 1 |
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6192586029 |
|---|---|
| Minimum | 0 |
| Maximum | 67 |
| Zeros | 6004 |
| Zeros (%) | 88.7% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4 |
| Maximum | 67 |
| Range | 67 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.598899002 |
|---|---|
| Coefficient of variation (CV) | 4.196791115 |
| Kurtosis | 181.233607 |
| Mean | 0.6192586029 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.24146107 |
| Sum | 4193 |
| Variance | 6.754276023 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6004 | 88.7% | |
| 4 | 156 | 2.3% | |
| 2 | 132 | 1.9% | |
| 3 | 93 | 1.4% | |
| 1 | 76 | 1.1% | |
| 6 | 65 | 1.0% | |
| 5 | 53 | 0.8% | |
| 8 | 44 | 0.6% | |
| 7 | 31 | 0.5% | |
| 9 | 25 | 0.4% | |
| Other values (19) | 92 | 1.4% |
| Value | Count | Frequency (%) | |
| 0 | 6004 | 88.7% | |
| 1 | 76 | 1.1% | |
| 2 | 132 | 1.9% | |
| 3 | 93 | 1.4% | |
| 4 | 156 | 2.3% |
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 61 | 2 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 32 | 2 | < 0.1% | |
| 31 | 1 | < 0.1% |
flt_leg_d_cnt_y3
Categorical
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 52.9 KiB |
| 0 | |
|---|---|
| 2 | 69 |
| 1 | 69 |
| 3 | 48 |
| 4 | 32 |
| Other values (35) | 132 |
| Value | Count | Frequency (%) | |
| 0 | 6421 | 94.8% | |
| 2 | 69 | 1.0% | |
| 1 | 69 | 1.0% | |
| 3 | 48 | 0.7% | |
| 4 | 32 | 0.5% | |
| {'1': 0, '2': 0, '3': 0, '4': 0, '5': 0, '6': 0} | 26 | 0.4% | |
| 5 | 17 | 0.3% | |
| 6 | 16 | 0.2% | |
| 7 | 14 | 0.2% | |
| 9 | 9 | 0.1% | |
| Other values (30) | 50 | 0.7% |
Unique
| Unique | 20 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 48 |
|---|---|
| Median length | 1 |
| Mean length | 1.336434795 |
| Min length | 1 |
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.064829212 |
|---|---|
| Minimum | 0 |
| Maximum | 300 |
| Zeros | 6103 |
| Zeros (%) | 90.1% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 70 |
| Maximum | 300 |
| Range | 300 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 30.7266159 |
|---|---|
| Coefficient of variation (CV) | 3.809952461 |
| Kurtosis | 24.75570153 |
| Mean | 8.064829212 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.70023363 |
| Sum | 54606.95859 |
| Variance | 944.1249249 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6103 | 90.1% | |
| 20 | 123 | 1.8% | |
| 50 | 66 | 1.0% | |
| 40 | 55 | 0.8% | |
| 120 | 55 | 0.8% | |
| 70 | 42 | 0.6% | |
| 130 | 32 | 0.5% | |
| 100 | 32 | 0.5% | |
| 10 | 31 | 0.5% | |
| 140 | 27 | 0.4% | |
| Other values (15) | 205 | 3.0% |
| Value | Count | Frequency (%) | |
| 0 | 6103 | 90.1% | |
| 10 | 31 | 0.5% | |
| 20 | 123 | 1.8% | |
| 28.195679 | 1 | < 0.1% | |
| 29.38145729 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 300 | 4 | 0.1% | |
| 250 | 11 | 0.2% | |
| 220 | 11 | 0.2% | |
| 210 | 5 | 0.1% | |
| 200 | 8 | 0.1% |
| Distinct | 461 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.2141837 |
|---|---|
| Minimum | 0 |
| Maximum | 13654.92 |
| Zeros | 6266 |
| Zeros (%) | 92.5% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 417.9521428 |
| Maximum | 13654.92 |
| Range | 13654.92 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 591.2974563 |
|---|---|
| Coefficient of variation (CV) | 5.78488655 |
| Kurtosis | 137.4922901 |
| Mean | 102.2141837 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.03331538 |
| Sum | 692092.2376 |
| Variance | 349632.6818 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6266 | 92.5% | |
| 2493.655 | 3 | < 0.1% | |
| 850.47375 | 3 | < 0.1% | |
| 5320.203684 | 3 | < 0.1% | |
| 1121.289474 | 3 | < 0.1% | |
| 257.4011111 | 3 | < 0.1% | |
| 213.06125 | 2 | < 0.1% | |
| 733.285 | 2 | < 0.1% | |
| 520.6 | 2 | < 0.1% | |
| 3336.295 | 2 | < 0.1% | |
| Other values (451) | 482 | 7.1% |
| Value | Count | Frequency (%) | |
| 0 | 6266 | 92.5% | |
| 0.0025 | 1 | < 0.1% | |
| 14.585 | 1 | < 0.1% | |
| 15.064 | 1 | < 0.1% | |
| 15.11170732 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13654.92 | 1 | < 0.1% | |
| 11712.67667 | 1 | < 0.1% | |
| 9937.415 | 1 | < 0.1% | |
| 9079.455 | 1 | < 0.1% | |
| 9020.44 | 1 | < 0.1% |
| Distinct | 593 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 182.3033287 |
|---|---|
| Minimum | 0 |
| Maximum | 21898.53 |
| Zeros | 6128 |
| Zeros (%) | 90.5% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 995.95875 |
| Maximum | 21898.53 |
| Range | 21898.53 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 920.5085624 |
|---|---|
| Coefficient of variation (CV) | 5.049323943 |
| Kurtosis | 120.6585729 |
| Mean | 182.3033287 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.176780875 |
| Sum | 1234375.838 |
| Variance | 847336.0134 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6128 | 90.5% | |
| 2267.455789 | 3 | < 0.1% | |
| 1589.5025 | 3 | < 0.1% | |
| 2790.383333 | 3 | < 0.1% | |
| 636.3088889 | 3 | < 0.1% | |
| 5320.203684 | 3 | < 0.1% | |
| 1249.099 | 2 | < 0.1% | |
| 830.6375 | 2 | < 0.1% | |
| 2579.4495 | 2 | < 0.1% | |
| 525.352 | 2 | < 0.1% | |
| Other values (583) | 620 | 9.2% |
| Value | Count | Frequency (%) | |
| 0 | 6128 | 90.5% | |
| 15.064 | 1 | < 0.1% | |
| 25.54 | 1 | < 0.1% | |
| 43.4675 | 1 | < 0.1% | |
| 72.575 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 21898.53 | 1 | < 0.1% | |
| 16115.70333 | 1 | < 0.1% | |
| 14113.38 | 1 | < 0.1% | |
| 13654.92 | 1 | < 0.1% | |
| 13598.805 | 1 | < 0.1% |
| Distinct | 618 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208.1421056 |
|---|---|
| Minimum | 0 |
| Maximum | 21898.53 |
| Zeros | 6102 |
| Zeros (%) | 90.1% |
| Memory size | 52.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1129.823333 |
| Maximum | 21898.53 |
| Range | 21898.53 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1012.999276 |
|---|---|
| Coefficient of variation (CV) | 4.866863785 |
| Kurtosis | 99.24700009 |
| Mean | 208.1421056 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.509208362 |
| Sum | 1409330.197 |
| Variance | 1026167.533 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6102 | 90.1% | |
| 5320.203684 | 3 | < 0.1% | |
| 686.3827778 | 3 | < 0.1% | |
| 2790.383333 | 3 | < 0.1% | |
| 1773.83 | 3 | < 0.1% | |
| 3489.626842 | 3 | < 0.1% | |
| 2158.444444 | 2 | < 0.1% | |
| 936.2883333 | 2 | < 0.1% | |
| 1257.78 | 2 | < 0.1% | |
| 826.545 | 2 | < 0.1% | |
| Other values (608) | 646 | 9.5% |
| Value | Count | Frequency (%) | |
| 0 | 6102 | 90.1% | |
| 15.064 | 1 | < 0.1% | |
| 43.4675 | 1 | < 0.1% | |
| 56.95 | 1 | < 0.1% | |
| 107.278 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 21898.53 | 1 | < 0.1% | |
| 16115.70333 | 1 | < 0.1% | |
| 14113.38 | 1 | < 0.1% | |
| 13862.975 | 1 | < 0.1% | |
| 13654.92 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| pax_name | pax_passport | seg_route_to | seg_flight | seg_cabin | emd_lable | emd_lable2 | gender | age | residence_country | nation_name | province_name | member_level | enroll_chnl | pref_aircraft_m3_1 | pref_aircraft_m3_2 | pref_aircraft_y3_1 | pref_aircraft_y3_2 | pref_aircraft_y3_3 | pref_aircraft_y3_4 | pref_aircraft_y3_5 | pref_line_y3_1 | pref_line_y3_2 | pref_line_y3_3 | pref_line_y3_4 | pref_line_y3_5 | pref_city_y3_1 | pref_city_y3_2 | pref_city_y3_3 | pref_dest_city_y1 | pref_dest_city_y2 | pref_dest_city_y3 | pit_add_chnl_y3 | seat_walkway_cnt_y3 | seat_window_cnt_y3 | seat_middle_cnt_y3 | avg_dist_cnt_y2 | avg_dist_cnt_y3 | flt_cnt_y3 | flt_leg_i_cnt_y3 | flt_leg_d_cnt_y3 | mdl_mcv | tkt_avg_amt_y1 | tkt_avg_amt_y2 | tkt_avg_amt_y3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 21f0b1c838160ac26cb2c57660bc3fd5 | 83685748783343bccba7a8c3c6a5c813 | JFK | AB1010 | Y | 0 | 0 | 0 | 51-60 | 0 | 美国 | SH | STD | 其它 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CAN-SHA | YVR-PVG | SHA-CAN | PVG-JFK | PVG-YVR | 0 | 0 | 0 | New York | Shanghai | Shanghai | 0 | 0 | 1 | 0 | 8636.8 | 5658.923077 | 13 | 0 | 7 | 130.0 | 282.256923 | 524.7500 | 920.134615 |
| 1 | 21e0621a85f6db6139ff7cf2d53b4e5d | 38da646d04551c8ad4652ab9d8a944b0 | LAX | AB1008 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.0000 | 0.000000 |
| 2 | 197b215b23a93b19f391c422eb27f310 | d9ac3f8a7ae010694f2391558a24129c | JFK | AB1010 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | JFK-PVG | PVG-KUL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | KUALA LUMPUR | KUALA LUMPUR | 0 | 0 | 2 | 0 | 8749.0 | 8749.000000 | 2 | 0 | 0 | 10.0 | 0.000000 | 364.4250 | 364.425000 |
| 3 | 92b435f20c6ce2fd5acef7b6ff49b6d0 | 1ffdb2de8c1ef1c7176f89cbf567ab10 | LAX | AB1009 | Y | 0 | 0 | F | 0 | 中国 | 0 | 0 | 0 | 0 | 0 | 0 | 773 | 33E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PVG | SIN | LAX | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0.0 | 0.000000 | 0 | 4 | 0 | 0.0 | 0.000000 | 0.0000 | 0.000000 |
| 4 | a38ac8bfe0feb14c0469e2917bc74a05 | 231a4d2ca500b1bcfb0abcd0247057d0 | JFK | AB1006 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.0000 | 0.000000 |
| 5 | 6f514830842c0132578432753b701d24 | eee37b2637ec23d01f92432b2063bf05 | JFK | AB1010 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.0000 | 0.000000 |
| 6 | 65e4bbac21f671d39faf6c76c0a9285e | 69615860c506fc4fdf5251458424e2f9 | JFK | AB1006 | Y | 0 | 0 | 0 | 21-30 | 0 | 泰国 | 0 | STD | 网站 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PVG-BKK | JFK-PVG | PVG-JFK | BKK-PVG | 0 | 0 | 0 | 0 | 0 | Shanghai | Shanghai | 0 | 0 | 4 | 0 | 8168.0 | 8168.000000 | 4 | 0 | 0 | 30.0 | 0.000000 | 529.4950 | 529.495000 |
| 7 | 47ccbe82525a0dbb19bf17487d4b5b5a | 53c6b18e06dec04b82e88c5e3a73c91c | JFK | AB1006 | Y | 0 | 0 | 0 | 21-30 | 0 | 美国 | 0 | STD | 网站 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | JFK-PVG | HND-PVG | PVG-HND | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Shanghai | 0 | 0 | 0 | 0 | 1740.0 | 5493.333333 | 3 | 0 | 0 | 20.0 | 0.000000 | 0.0000 | 579.643333 |
| 8 | b25c0d141bf303ad1cb3051f5bed8729 | 6016a0a65aecb2088129b99d12ecc5b9 | LAX | AB1008 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.0000 | 0.000000 |
| 9 | 8990a44ca0a7448b1dae1f2bb88faef7 | b580dd1d656b12eda4a8a26007327ccb | LAX | AB1009 | Y | 0 | 0 | F | 21-30 | 中国 | 美国 | JS | STD | 网站 | 0 | 0 | 773 | 319 | 0 | 0 | 0 | PVG-LAX | SFO-PVG | NKG-PVG | 0 | 0 | PVG | LAX | 0 | 0 | Los Angeles | Los Angeles | 航空累积 | 2 | 0 | 2 | 10929.0 | 8234.750000 | 4 | 3 | 1 | 50.0 | 0.000000 | 953.4575 | 1396.190000 |
Last rows
| pax_name | pax_passport | seg_route_to | seg_flight | seg_cabin | emd_lable | emd_lable2 | gender | age | residence_country | nation_name | province_name | member_level | enroll_chnl | pref_aircraft_m3_1 | pref_aircraft_m3_2 | pref_aircraft_y3_1 | pref_aircraft_y3_2 | pref_aircraft_y3_3 | pref_aircraft_y3_4 | pref_aircraft_y3_5 | pref_line_y3_1 | pref_line_y3_2 | pref_line_y3_3 | pref_line_y3_4 | pref_line_y3_5 | pref_city_y3_1 | pref_city_y3_2 | pref_city_y3_3 | pref_dest_city_y1 | pref_dest_city_y2 | pref_dest_city_y3 | pit_add_chnl_y3 | seat_walkway_cnt_y3 | seat_window_cnt_y3 | seat_middle_cnt_y3 | avg_dist_cnt_y2 | avg_dist_cnt_y3 | flt_cnt_y3 | flt_leg_i_cnt_y3 | flt_leg_d_cnt_y3 | mdl_mcv | tkt_avg_amt_y1 | tkt_avg_amt_y2 | tkt_avg_amt_y3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6761 | cb3bcf8538eb2e5b080984f75aef3c24 | d2716cfab47e5f18388ef8b969038df7 | JFK | AB1010 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6762 | a8d291065d09b799ee32efb7e0e28d01 | dda7c0f122e1819b2b996ace36f58a37 | LAX | AB1009 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6763 | dd3213d717570f08b0279c3f8be1c2ab | 02cded3cd573a95904acd6b427757447 | LAX | AB1008 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6764 | b4bd21f8e42a897a727643b41bf663a8 | 12f1872669e1d4bfa5367de9e7ace695 | LAX | AB1009 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6765 | 8f1f3dc11de90cdd555a7d30c62d7343 | 8a8a0ee98e173da437dec2b87447634d | JFK | AB1006 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6766 | d6364954adcfbd58d8beebd686a9fbdc | 931a5e027bd353621276e0dd895e1891 | LAX | AB1008 | J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6767 | 150b405be4282907eb7e87f992856ea1 | 1a17953ed59e6239239d4dda9155c2b8 | LAX | AB1008 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6768 | 33b02fadd0d05938b8cc3dfbc735fd10 | e33a28587bd6a9d49506dfde4fc4cd49 | JFK | AB1006 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6769 | 29cb3dea4ecce778096484ff2e097f5b | c12d4deab331a243c15617501d24851e | JFK | AB1010 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6770 | ded3592dc9da0c1ace02ed8e361efc23 | c9e0dced06ef5c9037bc3a0315a4704f | LAX | AB1008 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
Most frequent
| pax_name | pax_passport | seg_route_to | seg_flight | seg_cabin | emd_lable | emd_lable2 | gender | age | residence_country | nation_name | province_name | member_level | enroll_chnl | pref_aircraft_m3_1 | pref_aircraft_m3_2 | pref_aircraft_y3_1 | pref_aircraft_y3_2 | pref_aircraft_y3_3 | pref_aircraft_y3_4 | pref_aircraft_y3_5 | pref_line_y3_1 | pref_line_y3_2 | pref_line_y3_3 | pref_line_y3_4 | pref_line_y3_5 | pref_city_y3_1 | pref_city_y3_2 | pref_city_y3_3 | pref_dest_city_y1 | pref_dest_city_y2 | pref_dest_city_y3 | pit_add_chnl_y3 | seat_walkway_cnt_y3 | seat_window_cnt_y3 | seat_middle_cnt_y3 | avg_dist_cnt_y2 | avg_dist_cnt_y3 | flt_cnt_y3 | flt_leg_i_cnt_y3 | flt_leg_d_cnt_y3 | mdl_mcv | tkt_avg_amt_y1 | tkt_avg_amt_y2 | tkt_avg_amt_y3 | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84 | 884e2983a0740b728adb5aa8be5d5837 | 04706e7ca865da4e565d92593968add9 | JFK | AB1006 | J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 5 |
| 74 | 7623c905c7b5f3155e67e1647008c985 | 5fcafded7a9ecb863973769193664b22 | LAX | AB1008 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 4 |
| 58 | 5bfbe93dce75d9c22c47e87bd9359b39 | 1b97eba650abecbf9d9eecdee912a370 | LAX | AB1008 | J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 3 |
| 68 | 6c6dce7c8c665df07ccc3d01ff2b5f86 | eba97d2a193f832add8c2db9aa23a82f | LAX | AB1008 | Y | 0 | 0 | F | 0 | 中国 | 0 | 0 | 0 | 0 | 773 | 73V | 773 | 73E | 325 | 320 | 76E | 0 | 0 | 0 | 0 | 0 | SZX | SHA | PVG | 0 | 0 | 0 | 航空累积 | 21 | 0 | 5 | 0.000 | 0.000000 | 0 | 15 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 3 |
| 76 | 779999ae7a2cf515220842c0d27ca4d9 | b54899ca796ba16a928dd77b6c65da5e | LAX | AB1009 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 3 |
| 87 | 8b1310e1ad2ed70c1fef327369eb29d4 | 0cf357779a8597a092bdb7e8c4dd0fb9 | LAX | AB1009 | J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 3 |
| 102 | 9c7c4b0a727a1abf489877aecea3c8e6 | 4310eb2e24571f724e6227d9196cefb0 | JFK | AB1006 | Y | 0 | 0 | M | 31-40 | 中国 | 美国 | 0 | STD | 网站 | 773 | 773 | 773 | 773 | 773 | 773 | 773 | JFK-PVG | PVG-JFK | 0 | 0 | 0 | PVG | JFK | 0 | New York | New York | New York | 航空累积 | 5 | 0 | 1 | 13239.000 | 13239.000000 | 6 | 6 | 0 | 120.0 | 2493.655000 | 2790.383333 | 2790.383333 | 3 |
| 122 | c1a28b8b969ecdd74a7b6b01af76c71e | 72f0bf3f0d855bfa95dabc3e8e435c4f | LAX | AB1008 | J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 3 |
| 125 | c44e7e31e3f4562f639ca18a6f3cde06 | dbe116c4a1eb51b0c6cb14e9f62a11e5 | JFK | AB1006 | Y | 0 | 0 | 0 | 60+ | 0 | 中国 | NY | STD | 网站 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PVG-JFK | JFK-PVG | PVG-CGO | CGO-PVG | CGO-SHA | 0 | 0 | 0 | Shanghai | Shanghai | Shanghai | 0 | 0 | 4 | 0 | 6998.875 | 6992.722222 | 18 | 0 | 9 | 220.0 | 257.401111 | 636.308889 | 686.382778 | 3 |
| 145 | d933b7ab2b0b2587eba24c5bb9da5ff7 | 80d2f5950df6944e6cb23255e6daa1ce | LAX | AB1009 | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.000 | 0.000000 | 0 | 0 | 0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 3 |